Quiz 11
Question # 1
Which query/ queries will print the views in the MovieIndustry database?
A)
SHOW TABLES IN MovieIndustry
WHERE table_type='VIEW';
B)
SHOW FULL TABLES IN MovieIndustry
WHERE table_type='VIEW';
C)
SELECT * FROM information_schema.tables
WHERE table_type='VIEW';
D)
SELECT VIEWS FROM information_schema.tables;
Question # 2
Which privilege do you need to drop a stored procedure?
A)
ALTER ROUTINE
B)
DROP ROUTINE
C)
EXECUTE
Question # 3
Consider a table that stores information of students and their courses. Find the SQL statement below that is equal to the following:
SELECT name FROM student WHERE course = 'MySQL';
A)
SELECT name IN student WHERE course = 'MySQL';
B)
SELECT name IN student WHERE course IN ('MySQL');
C)
SELECT name FROM student WHERE course IN ('MySQL');
Question # 4
Choose the option/options that describe Database White Box Testing:
A)
Referential integrity rules
B)
Data Mapping
C)
Database consistency and ACID properties
D)
Decision Coverage, Condition Coverage, and Statement Coverage
Question # 5
Choose the option/options that describe Database Black Box Testing:
A)
Database Tables, Data Model, and Database Schema
B)
Equivalence Partitioning and Boundary Value Analysis (BVA)
C)
Data Mapping
D)
Decision Coverage, Condition Coverage, and Statement Coverage
E)
Data stored and retrieved
